Creating Reports

The Create Report command automatically creates a worksheet with database rows containing data from existing symbols or record formats.

To create a report from record formats or symbols:

1.	Select Tools > Reports > Create Report.

The Create Report dialog box opens. Specify the report criteria. Items in the Worksheet Columns list are listed in the order in which they will appear in the worksheet; to change the order, click in the # column and drag the item to the desired position in the list and worksheet.

 

Parameter	Description
Title	Assign a worksheet title
List all	Select to either list all objects with a record or list all symbols
List objects with record	If listing all objects with a record, select the record format to include
Possible Columns	Lists the columns that can be selected for inclusion in the worksheet
Worksheet Columns	Lists the columns selected for inclusion in the worksheet. Initially, all possible columns are placed in the Worksheet Columns list. Items that will be used as worksheet columns appear dimmed in the Possible Columns list.
Add / Add All	To add a column to the worksheet, select it in the Possible Columns list and click Add; click Add All to move all the columns to the Worksheet Columns list
Remove / Remove All	To remove an item from the worksheet, select it in the Worksheet Columns list and click Remove; click Remove All to move all the columns to the Possible Columns list
Summarize items with the same	Summarizes symbols or record formats containing identical fields, rather than creating a new database row for each; select the field to summarize
Options	Specifies additional report options

2.	Click Options to specify additional report criteria.

The Create Report Options dialog box opens.

 

Parameter	Description
New worksheet	Select to create a new worksheet
Append to existing worksheet	Select to append the information to a worksheet, and then select the target worksheet
Search in symbols	Select to search symbol instances for embedded records and symbols or include this information in the worksheet
Search in plug-in objects	Select to search plug-in object instances for embedded records or symbols and include this information in the worksheet

3.	Click OK to return to the Create Report dialog box.

4.	Click OK to create the worksheet.

The worksheet opens automatically and consists of the specified columns, and contains a sub-row for each object or symbol in the drawing. The first data row shows the total value for the column.

5.	The worksheet is saved with the file and is listed in the Resource Browser.